select r1.rser_anno, r1.rser_id, (SELECT tm.TRS_DES FROM RICSER RM, v_trsver$ tm WHERE RM.AZ_ID = r1.AZ_ID AND RM.RSER_ID = r1.rser_id AND RM.RSER_ANNO = r1.rser_anno AND tm.amb_id = RM.amb_id AND tm.trsv_id = RM.trsv_id) as trs_des from ricservalpar r1 where (r1.az_id, r1.TRSVP_VALPAR) in ( select az_id, to_char(csi_id) from contratto where az_id = '01'
and con_anno = ^CON_ANNO;N;Numerico^^
and con_id   = ^CON_ID;N;Numerico^^
)
order by r1.rser_anno, r1.rser_id
